﻿CREATE TABLE [dbo].[Agentes] (
    [AgenteGuid]   UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [AgenteId]     INT              NOT NULL,
    [AclGuid]      UNIQUEIDENTIFIER NOT NULL,
    [AclId]        INT              NOT NULL,
    [JuntaGuid]    UNIQUEIDENTIFIER NOT NULL,
    [JuntaId]      INT              NOT NULL,
    [Nombre]       NVARCHAR (100)   NOT NULL,
    [Apellido]     NVARCHAR (250)   NOT NULL,
    [Domicilio]    NTEXT            NULL,
    [Email]        NVARCHAR (250)   NULL,
    [Telefono]     NVARCHAR (50)    NULL,
    [Usuario]      NVARCHAR (100)   NOT NULL,
    [PasswordHash] NVARCHAR (250)   NOT NULL,
    [PasswordSalt] NVARCHAR (250)   NOT NULL,
    [Status]       BIT              NOT NULL
);





GO
ALTER TABLE [dbo].[Agentes] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF);



